package com.lanou3g.ptp.user.mapper;

import com.lanou3g.ptp.entity.User;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
public interface UserMapper {
    //通过id 查询对应信息
    User userById(Long id);

    List<User> userByName(String name);

    int deleteById(Long id);

    int upUser(User user);

    int addUser(User user);

    Long userByNo(String no);

    User userByPassword(String password);

    List<User> findByCollegeId(Long collegeId);

    List<User> findByMajorId(Long majorId);
}